Use this database file to track purchase orders. FileMaker Pro automatically calculates sales tax and product discounts.
How to use this solution
You can update the sales tax and discount rate by updating the values in those fields
How to customize this solution
You can look up the customer information from your own Customers file based on the Customer ID field.
You can create a new file with your shippers rates by ZIP Code, and then redefine the Shipping Rate field to autoB:matically look up the rate based on the Customer ZIP Code.
Form View - Sale
A List View
Invoice Report
Information
Report Menu
@>A!Form View - Customer and Shipping
Form View - SaleB
Customer ZIP CodeB
Date CreatedB
Date ModifiedB
Customer CityB
Customer CompanyB
SubtotalB
Sales Tax RateB
.A Sales TaxB
4) *
ShippingB
Invoice TotalB
Discount RateB
DiscountB
7A Ship DateB
TermsB
Net 30
F.O.B.B
Ship ViaB
Ground
WeightB
Created ByB
InfoB
Customer IDB
Amount PaidB
Amount DueB
Customer CountryB
Shipping RateB
Customer PhoneB
Customer FaxB
Last LayoutB
Open Script
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Enter data for Product Sales
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
Customer &
Shipping
Product Sales
Line Items File...
Inventory File...
Invoice ID
Invoice Date
Subtotal
Discount
Shipping
Total
Prod. ID
Description
Price
Extended Amount
Cust. ID
Company
Amount Paid
Amount Due
Discount Rate
Tax Rate
Ship Date
Terms
A List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Totalb
Customer Namec
Dated
Invoice IDe&Click to see more information for Salef
Infog
Closeh
View As
Formi
View As
Listj
Reportsk
Recordl
Delete
Recordm
Recordn
Your Own
Buttono
Your Own
Button
Customer Company
u Ship Date
Invoice ReportB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Extended Amount
Price
Quantity
Description
Weight
Invoice Total
Shipping
Discount
Subtotal
Ship Via
n Ship Date
F.O.B.
Terms
Customer
Invoice Date
Invoice
Company Name and Logo
Close
View As
View As
Reports
Your Own
Button
ABCA>>, <<
ABAI>> <<
ABAK>>
ABEG>>
Invoice ID
Product ID
InformationB
P-Information about the Purchase Sales solutionQ
Info for this SolutionS
InfoT
CloseU
View As
FormV
View As
ListW
ReportsX
Your Own
Button
Report MenuB
Your Own
ReportI
Your Own
ReportJ
InvoiceK
Your Own
ReportL>Click on any of these buttons to preview the respective reportM
Select a reportN
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
A!Form View - Customer and ShippingB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Invoice Date
Invoice ID
Enter data for Product Sales
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
Product Sales
Inventory File...
Line Items File...
Company
Address
City / State / ZIP Code
Country
Customer &
Shipping
Shipping:
Rate ($/lb)
Weight (lbs)
Ship Date
Ship Via
F.O.B.
Customer
Shipping
Phone
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)